package org.eoti.io.xls;

/**
 * The MIT License
 * <p/>
 * Copyright (c) 2009 Malachi de AElfweald (malachid@gmail.com)
 * <p/>
 * Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
 * documentation files (the "Software"), to deal in the Software without restriction, including without limitation the
 * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to
 * permit persons to whom the Software is furnished to do so, subject to the following conditions:
 * <p/>
 * The above copyright notice and this permission notice shall be included in all copies or substantial portions of the
 * Software.
 * <p/>
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
 * WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR
 * COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR
 * OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 */
import java.util.*;
import java.text.SimpleDateFormat;
import java.text.ParseException;

public class TimeHandler
	extends CellHandler<Date>
{
	protected SimpleDateFormat sdf;

	public TimeHandler(XLSColumn column)
	{
		super(column);
		sdf = new SimpleDateFormat("hhmm");
	}

	public Date getValue(int rowNum)
	{
		String s = "" + (int)(column.getCell(rowNum).getNumericCellValue());
		if(s.length() == 3) s = "0"+s;
		try{
			Calendar cal = Calendar.getInstance();
			cal.setTime(sdf.parse(s));
			if(cal.get(Calendar.HOUR) < 8)
				cal.set(Calendar.AM_PM, Calendar.PM);

			return cal.getTime();
		} catch(ParseException e){
			return null;
		}
/*
		Calendar now = Calendar.getInstance();
		if(s.length() == 3) s = "0"+s;
		now.set(Calendar.HOUR, Integer.valueOf(s.substring(0,2)));
		now.set(Calendar.MINUTE, Integer.valueOf(s.substring(2)));
		if(now.get(Calendar.HOUR) < 8)
			now.set(Calendar.HOUR, now.get(Calendar.HOUR)+12);

		return now.getTime();
*/

	}

	public String getString(int rowNum)
	{
		Date d = getValue(rowNum);
		if(d == null) return "";
		return String.format("%1$tI:%1$tM %1$Tp", d);
	}
}
